Diagram GEN_MedResource

Defincja diagramu GEN_MedResource

Name

GEN_MedResource

Code

GEN_MedResource

Comment

Defines medical resource model (personnel, medical equipement)


Lista tabel diagramu

Name

Code

Degree

Degree

DegreeText

DegreeText

DictionaryValue

DictionaryValue

Equipment

Equipment

EquipmentText

EquipmentText

EquipmentType

EquipmentType

EquipmentTypeText

EquipmentTypeText

ExternalDoctor

ExternalDoctor

InterpretationType

InterpretationType

LEquipmentPerfService

LEquipmentPerfService

LEquipmentType

LEquipmentType

LExternalDoctorSpeciality

LExternalDoctorSpeciality

LMedResourceOrgUnit

LMedResourceOrgUnit

LOrgUnitSpeciality

LOrgUnitSpeciality

LPersonnelDegree

LPersonnelDegree

LPersonnelSpeciality

LPersonnelSpeciality

LPersonnelType

LPersonnelType

LServiceEquipment

LServiceEquipment

LServiceMaterial

LServiceMaterial

MedResource

MedResource

PerfResource

PerfResource

PerfService

PerfService

PerfServPerfServTimeDependency

PerfServPerfServTimeDependency

Personnel

Personnel

PersonnelType

PersonnelType

PersonnelTypeText

PersonnelTypeText

Service

Service

Speciality

Speciality

SpecialityKind

SpecialityKind

SpecialityKindText

SpecialityKindText

SpecialityText

SpecialityText

StuffGrade

StuffGrade

StuffGradeText

StuffGradeText

TestTube

TestTube

TestTubeText

TestTubeText

TimeDependencyType

TimeDependencyType

TimeDependencyTypeText

TimeDependencyTypeText

Unit

Unit


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_147

R_147

PerfService

PerfResource

PerfServiceID

 

 

R_366

R_366

Personnel

LPersonnelType

PersonID

 

 

R_367

R_367

PersonnelType

LPersonnelType

PersonnelTypeID

 

 

R_378

R_378

PersonnelType

PersonnelTypeText

PersonnelTypeID

 

 

R_380

R_380

Equipment

EquipmentText

EquipmentID

 

 

R_397

R_397

EquipmentType

LEquipmentType

EquipmentTypeID

 

 

R_398

R_398

EquipmentType

EquipmentTypeText

EquipmentTypeID

 

 

R_400

R_400

MedResource

LMedResourceOrgUnit

MedResourceID

 

 

R_401

R_401

Personnel

MedResource

PersonID

 

 

R_402

R_402

Equipment

MedResource

EquipmentID

 

 

R_403

R_403

Equipment

LEquipmentType

EquipmentID

 

 

R_631

R_631

Equipment

LServiceEquipment

EquipmentID

 

 

R_638

R_638

Service

LServiceEquipment

ServID

 

 

R_644

R_644

Unit

LServiceEquipment

UnitID

 

 

R_646

R_646

Unit

Equipment

UnitID

 

 

R_682

R_682

Unit

Service

UnitID

 

 

R_697

R_697

Speciality

SpecialityText

SpecialityID

 

 

R_698

R_698

Personnel

LPersonnelSpeciality

PersonID

 

 

R_699

R_699

Speciality

LPersonnelSpeciality

SpecialityID

 

 

R_893

R_893

LPersonnelType

LMedResourceOrgUnit

LPersonnelTypeID

 

 

R_1144

R_1144

Personnel

LPersonnelDegree

PersonID

 

 

R_1145

R_1145

Degree

LPersonnelDegree

DegreeID

 

 

R_1146

R_1146

Degree

DegreeText

DegreeID

 

 

R_1379

R_1379

StuffGrade

StuffGradeText

StuffGradeID

 

 

R_1381

R_1381

StuffGrade

LPersonnelSpeciality

StuffGradeID

 

 

R_1422

R_1422

Speciality

ExternalDoctor

SpecialityID

 

 

R_1423

R_1423

StuffGrade

ExternalDoctor

StuffGradeID

 

 

R_1424

R_1424

Degree

ExternalDoctor

DegreeID

 

 

R_1524

R_1524

Unit

PerfResource

UnitID

 

 

R_5021

R_5021

Speciality

LOrgUnitSpeciality

SpecialityID

 

 

R_8090

R_8090

ExternalDoctor

LExternalDoctorSpeciality

ExternalDoctorID

 

 

R_8091

R_8091

Speciality

LExternalDoctorSpeciality

SpecialityID

 

 

R_8092

R_8092

StuffGrade

LExternalDoctorSpeciality

StuffGradeID

 

 

R_8590

R_8590

Equipment

PerfService

EquipmentID

 

 

R_8920

R_8920

PerfService

PerfServPerfServTimeDependency

PerfServiceID

 

 

R_8921

R_8921

PerfService

PerfServPerfServTimeDependency

Per_PerfServiceID

 

 

R_8922

R_8922

TimeDependencyType

PerfServPerfServTimeDependency

TimeDependencyTypeID

 

 

R_8923

R_8923

PerfResource

PerfServPerfServTimeDependency

PerfResourceID

 

 

R_8924

R_8924

TimeDependencyType

TimeDependencyTypeText

TimeDependencyTypeID

 

 

R_9200

R_9200

InterpretationType

PerfService

InterpretationTypeID

 

 

R_9250

R_9250

SpecialityKind

SpecialityKindText

SpecialityKindID

 

 

R_9251

R_9251

SpecialityKind

Speciality

SpecialityKindID

 

 

R_9797

R_9797

PerfResource

PerfResource

Per_PerfResourceID

 

 

R_9901

R_9901

Equipment

LEquipmentPerfService

EquipmentID

 

 

R_9902

R_9902

PerfService

LEquipmentPerfService

PerfServiceID

 

 

R_10175

R_10175

Unit

TestTube

UnitID

 

 

R_10176

R_10176

DictionaryValue

TestTube

TestTubeProducerID

 

 

R_10177

R_10177

DictionaryValue

TestTube

TestTubeTypeID

 

 

R_10178

R_10178

DictionaryValue

TestTube

TestTubeColorID

 

 

R_10179

R_10179

TestTube

TestTubeText

TestTubeID

 

 


2